USE [AnotherSuccessfulProcedure]

IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[RoundsInsert]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
	DROP PROCEDURE dbo.RoundsInsert
END


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Neil Wilson
-- Create date: 08/29/08
-- Description:	Rounds Table Insert
-- =============================================
CREATE PROCEDURE RoundsInsert

           @RoundId int,
           @WinningTeamId int,
           @LosingTeamId int,
           @WinningTeamScore int,
           @LosingTeamScore int,
           @RoundLengthSeconds int,
           @LogId int,
           @EndTime datetime
	

AS
BEGIN

INSERT INTO [Rounds]
           ([RoundId]
           ,[WinningTeamId]
           ,[LosingTeamId]
           ,[WinningTeamScore]
           ,[LosingTeamScore]
           ,[RoundLengthSeconds]
           ,[LogId]
           ,[EndTime])
     VALUES
           (@RoundId,
           @WinningTeamId,
           @LosingTeamId,
           @WinningTeamScore,
           @LosingTeamScore,
           @RoundLengthSeconds,
           @LogId,
           @EndTime)
END
GO
